﻿Use WarehouseManagement
Go

ALTER PROCEDURE GetCollectionWarehouse
(
@IsShowAll bit=0
)
AS
BEGIN
	SELECT 
			w.[WarehouseID]
			, w.[WarehouseName]
			, w.[Description]
			, w.[OfficePhone]
			, w.[Address]
			, w.[IsDelete]
	FROM 
			[Warehouse] w 
	WHERE 
			w.[IsDelete] = 0 OR w.[IsDelete] = @IsShowAll
END

/*
USE WarehouseManagement
GO

EXEC GetCollectionWarehouse
*/